UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xd28KSPB9CUsL9JqMpxMIRo6rz6fzZwVCm0mKV1cdIU='
WHERE
key_id = '3c4a5044acf15f2765b95f64f19e0c8aa3fd006f14ddaee6cf72d6a810d7d8cc'
AND (
token = 'xd28KSPB9CUsL9JqMpxMIRo6rz6fzZwVCm0mKV1cdIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)