UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'myUQyOXWTGG+JkO3179xAy12URROnT7qE1Xy3sdGLUw='
WHERE
key_id = 'd871685a89212fd888edbc43c6f21881cd4395200724311054bb8d329de50805'
AND (
token = 'myUQyOXWTGG+JkO3179xAy12URROnT7qE1Xy3sdGLUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)