UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QLOx5wUqym6KES1/BjduAhdhwts7eNSZ6QuU5H6a0tE='
WHERE
key_id = '7bd05819ae8a01de44a59968822d17f9e3ddb86f215f37b0b6706058a687a0ec'
AND (
token = 'QLOx5wUqym6KES1/BjduAhdhwts7eNSZ6QuU5H6a0tE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)