UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7lhR378AE2p8Mw04fCtqGfCAyeOPN+H/yeeI5RH2nw='
WHERE
key_id = 'ddf3e78a0c5bef0214ee76dab681ded8ad90e5a96cdef5a170609befc58dc41d'
AND (
token = 'b7lhR378AE2p8Mw04fCtqGfCAyeOPN+H/yeeI5RH2nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)