UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W96Nl/dJreOWApUIDMrVSVcpLGwI+a6Wuk7sYSAX0gE='
WHERE
key_id = '8d29c2163ba31bca89a4c802ae8f447ecf3953611c6bc6798de8c4e6a9128e11'
AND (
token = 'W96Nl/dJreOWApUIDMrVSVcpLGwI+a6Wuk7sYSAX0gE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)