UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y6a7MA6iMr191z0S2oS88CxvCd0Kc3zdGrCopcHCpbk='
WHERE
key_id = '70c5c334834799c2e97975576db509bfd1e02b828ea97ed4feafab64f5474715'
AND (
token = 'Y6a7MA6iMr191z0S2oS88CxvCd0Kc3zdGrCopcHCpbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)