UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pfoDk3wJNGHXZpG19X52njH64A1BnhwuQvQDbWo3/4='
WHERE
key_id = '4aaf6da246602eefb764dede66273ea7c90820700181ef0f840c47f4fc6cc902'
AND (
token = '9pfoDk3wJNGHXZpG19X52njH64A1BnhwuQvQDbWo3/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)