UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lGlK2jU5tFSo5/aXZvr2fwJtvR7H31J7T4a6F8VCecE='
WHERE
key_id = '9181d5c714ec9af9a410474e08362ed6ed5aaab387d74d73e333f9c42193800e'
AND (
token = 'lGlK2jU5tFSo5/aXZvr2fwJtvR7H31J7T4a6F8VCecE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)