UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XBGPX927o5IlUrfnUPF/GSWZIr3FmY+s5QLUkkhqig='
WHERE
key_id = 'eb3eacccbf881d96544f13c8214cbcdca44380a14b2623a21e9050264a5feaae'
AND (
token = '/XBGPX927o5IlUrfnUPF/GSWZIr3FmY+s5QLUkkhqig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)