UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3yyKDzkMAcwSVZpp9pdJa0hrF1ps0T7+akZidJBbZsg='
WHERE
key_id = '58d36df1ea7428b800be2585d978a15236e0712bcdb90139e40037b2c08e3457'
AND (
token = '3yyKDzkMAcwSVZpp9pdJa0hrF1ps0T7+akZidJBbZsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)