UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MIG+eXvuLfYRnWcWty/wB8Uvd30Ef77Kko6xlAbcAsI='
WHERE
key_id = '8c6bf38be3564b16ae649ca0d6a4faf8b0a644154b4c78fd891c7be7a071ded9'
AND (
token = 'MIG+eXvuLfYRnWcWty/wB8Uvd30Ef77Kko6xlAbcAsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)