UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kr/Kz86xyWKxbK2TiXaCCyCo5uIaI48Ewa7/c69Tb5k='
WHERE
key_id = 'ac4ff5f7ceb3e75c616a93001dd8315a07a09057a9e81c6b9e65392cd744a30d'
AND (
token = 'Kr/Kz86xyWKxbK2TiXaCCyCo5uIaI48Ewa7/c69Tb5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)