UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VKcuIi1lhWIjbjyGIu55eXFWO0sVrDFaRsQ1O1Jz690='
WHERE
key_id = 'b315bb213230f0fe97e811c3dba1272ed055cef38212ab269a4ce2d655e8298b'
AND (
token = 'VKcuIi1lhWIjbjyGIu55eXFWO0sVrDFaRsQ1O1Jz690='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)