UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9z2JMdfEDG5/+4y/qj0hmkcxiKDPIfN3wdA5Begh9Go='
WHERE
key_id = '29e0b7ace94102fa6a4eb72e8775e835d84677c93c0cb38368d99ef3313fc4c2'
AND (
token = '9z2JMdfEDG5/+4y/qj0hmkcxiKDPIfN3wdA5Begh9Go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)