UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kIk1n0ZH3XDSY7nXybHxjI0nTrTppGTD7HCA4xf+IMU='
WHERE
key_id = '595eb40927ed199506b0c53a6b71aaa2fa76a01afcd55249632f606272d8d47c'
AND (
token = 'kIk1n0ZH3XDSY7nXybHxjI0nTrTppGTD7HCA4xf+IMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)