UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnwwHPHZG2KcFUmTLy5QzrvA7589+vdDbUBYQKHpLNs='
WHERE
key_id = '567bc84cf78afbc4575d293879f68df75a8e5a5e8de453ea72b4462c39c21531'
AND (
token = 'ZnwwHPHZG2KcFUmTLy5QzrvA7589+vdDbUBYQKHpLNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)