UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4akr26T6N/wK9cozfkKZRwt31eVDlk/E5FLsqYz36fs='
WHERE
key_id = 'f9c51bbb368a87550ec2cd8f602e0cc9782e0637392292ea4e8c658f556fa1cb'
AND (
token = '4akr26T6N/wK9cozfkKZRwt31eVDlk/E5FLsqYz36fs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)