UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2HlLDh4hhitSn5SWxLCCFnl2RdeHo2Pko7khmYCwq/8='
WHERE
key_id = '392b5e85c31f905fd2a19a2df9f512f09b7c8ad501c5a81aecbe0b951defc710'
AND (
token = '2HlLDh4hhitSn5SWxLCCFnl2RdeHo2Pko7khmYCwq/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)