UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yPvxBAB7hKqE5TyYporhh6pfnu1VcYJuHn/HNmxWrow='
WHERE
key_id = 'bd704115d36a12a793b917b4ed7ddb1737097355a017331a63e1c7222a380236'
AND (
token = 'yPvxBAB7hKqE5TyYporhh6pfnu1VcYJuHn/HNmxWrow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)