UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yPapC2UBS0+qqIV6yazMVWOcWp/nxTgjTG+a4a13BIo='
WHERE
key_id = '0cf24dcac05b7013b7e90c3e17c744d607f5d1a45311b3e22fde58e6e520ddfb'
AND (
token = 'yPapC2UBS0+qqIV6yazMVWOcWp/nxTgjTG+a4a13BIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)