UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRSZkm/lkuvTIl5yUR2aN8/fGW5giFAfJhhvqJStmag='
WHERE
key_id = '25a097c50a37bc7fcb0e81e67938f95a10884fa661b1a3313dd1bdf7f6de9ed1'
AND (
token = 'pRSZkm/lkuvTIl5yUR2aN8/fGW5giFAfJhhvqJStmag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)