UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cr/k0T145/24KVaYlJO0llYD2/vjwPf+7QubYsYSKHM='
WHERE
key_id = '31d81b24d63c10973cca73d9a7b4d45887e0efe1048a3f16a295fe464350f41a'
AND (
token = 'Cr/k0T145/24KVaYlJO0llYD2/vjwPf+7QubYsYSKHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)