UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ITcTr9zADD0Wk3l/lBfIejzHinNLiu8vVOwQxAvRrZ8='
WHERE
key_id = '2ed2ae504e29ad6250ee245a4da2de73e2f803eaf5e555fce9d61bd43d36f5b4'
AND (
token = 'ITcTr9zADD0Wk3l/lBfIejzHinNLiu8vVOwQxAvRrZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)