UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJmkhAWffSOAzHMJowNX9cOtmDCmoCPuGlQmaIt2jbs='
WHERE
key_id = '8410e07dc78da5547d732f6a6fbe5410abfb467787b2b80490eda72c69ace371'
AND (
token = 'TJmkhAWffSOAzHMJowNX9cOtmDCmoCPuGlQmaIt2jbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)