UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I5iSnXr3djoD6BnLnP5u9bsau2QiFnMTsC/ut/5h+aM='
WHERE
key_id = '1c36293b938311811cf76a6c17f6835342f0910bffacc7e3f1496b19d4529ff1'
AND (
token = 'I5iSnXr3djoD6BnLnP5u9bsau2QiFnMTsC/ut/5h+aM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)