UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1r7ogFSfy2zvKzzk3h9iH4Nz+BCRHdiykyX7KOWFFU='
WHERE
key_id = '2ee89ad709344a83ab7e8b035b6f170b7f61f3f684dda04be1504fc340343264'
AND (
token = 'N1r7ogFSfy2zvKzzk3h9iH4Nz+BCRHdiykyX7KOWFFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)