UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tWVq4B5Wcqbz1LBXygUIZNE8Zxte7ODOHbSLn8YU6q8='
WHERE
key_id = 'dc61966da5dfd88247c67660378476d9f57bb609823697c473a5a14a7f154673'
AND (
token = 'tWVq4B5Wcqbz1LBXygUIZNE8Zxte7ODOHbSLn8YU6q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)