UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNbS3DXS2pw+B03+a2wZRWTKODKdycXWzXkYV0m6/eA='
WHERE
key_id = '7c704d14c79d48341bf8d0554c97a626ea04f5d49ef4f5ef90b09de9a7189027'
AND (
token = 'kNbS3DXS2pw+B03+a2wZRWTKODKdycXWzXkYV0m6/eA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)