UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oYReUu7JiYAPsVRpnU2WV4Conb5OXp13kS0rKvmRWU='
WHERE
key_id = '1f70ccde3a5acb59a6a2d9864df57d489a8daaea05e4307b0f486cd8832cbb27'
AND (
token = '9oYReUu7JiYAPsVRpnU2WV4Conb5OXp13kS0rKvmRWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)