UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OpDQLhR/bfD9e1lAAF2prdqs5NJe8ozWPEEGuAfC/rw='
WHERE
key_id = '7db6415ee180ef06d0cd97f5d1157825e2246fa9496a1c204f236f8841ec947a'
AND (
token = 'OpDQLhR/bfD9e1lAAF2prdqs5NJe8ozWPEEGuAfC/rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)