UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/NLdkJ+X1fSj1LcCLuye5ukamd4lvIYXE78icjdk01E='
WHERE
key_id = 'd11dedd0f83e22e840d639e20fd8491972ec22085b8afdbd34224e54e65972a4'
AND (
token = '/NLdkJ+X1fSj1LcCLuye5ukamd4lvIYXE78icjdk01E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)