UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEEbPwvDpDgNi1ne1BBxNtlDMh7a/JaK1iCJ48ojVgw='
WHERE
key_id = '1430c9bbf908bf71d1ce60d4f78bc300c7a8f65a20d6838bb7bf009f8e72a4e4'
AND (
token = 'oEEbPwvDpDgNi1ne1BBxNtlDMh7a/JaK1iCJ48ojVgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)